# Water quality data, gene copy number counts, and 16S analyses from Rhode River samples collected at SERC # PI: Sarah Preheim # Version history: # 2020-12-03 (v2; current)- addition of 2017 data and qPCR columns; # 2019-02-11 (v1) - 2018 data only. ========================= Sample ISO_DateTime_EST ISO_DateTime_UTC Temp Conductivity DO_pcnt Pressure pH Chlorophyll_RFU BGA_PE_RFU FDOM_RFU Specific_Conductivity Salinity DO Depth Turbidity Chlorophyll BGA_PE FDOM Location Lat Lon Instrumentation Sample_ID Genes_16S_1 Genes_16S_2 RNR_Genes_1 RNR_Genes_2 Library_Accession_Number_16S Shotgun_Metagenome_Library_Accession_Number Fusion_Amplicon_Accession_Numbers ------------------------- 5/24/18 2018-05-24T12:00 2018-05-24T17:00Z 23.72 10.03 112.2 1.55 8.4 9.9 20.6 13.2 10.28 5.81 9.19 1.09 7.2 29.9 51 38.5 SERC Dock 38.8869 -76.5402 YSI EXO2 SERC_5_24_18 5.12E+6 5.55E+5 1.03E+5 1.20E+4 SRR11791055 nd SRR11784306, SRR11784305, SRR11784352 5/31/18 2018-05-31T12:00 2018-05-31T17:00Z 25.37 9.53 104 1.43 8.1 26.1 45.4 12.7 9.46 5.3 8.28 1.01 12.16 78.9 112 37.09 SERC Dock 38.8869 -76.5403 YSI EXO2 SERC_5_31_18 4.67E+6 4.49E+5 3.15E+6 3.23E+5 SRR11791054 SRR11803380 SRR11784341, SRR11784330, SRR11784319, SRR11784310 6/8/18 2018-06-08T12:00 2018-06-08T17:00Z 24.4 8.7 127.3 1.54 8.6 22.1 41.8 11.8 8.8 4.91 10.34 1.08 13.12 67 104 34.62 SERC Dock 38.8869 -76.5404 YSI EXO2 SERC_6_8_18 4.39E+6 3.27E+5 2.18E+6 2.48E+5 SRR11791046 nd SRR11784309, SRR11784308, SRR11784307 6/14/18 2018-06-14T12:00 2018-06-14T17:00Z 24.82 8.69 78.6 1.42 7.7 7.4 12.3 10.2 8.72 4.86 6.34 1 14.34 22.3 31 30.08 SERC Dock 38.8869 -76.5405 YSI EXO2 SERC_6_14_18 6.04E+6 6.97E+5 1.44E+6 1.86E+5 SRR11791045 nd SRR11784304, SRR11784303, SRR11784360, SRR11784359 6/22/18 2018-06-22T12:00 2018-06-22T17:00Z 26.51 10.13 68.4 1.4 7.4 8 23.6 9 9.85 5.52 5.33 0.98 11.66 24.2 59 26.43 SERC Dock 38.8869 -76.5406 YSI EXO2 SERC_6_22_18 7.99E+6 1.13E+6 3.11E+6 3.71E+5 SRR11791044 nd SRR11784358, SRR11784357, SRR11784356, SRR11784355 6/28/18 2018-06-28T12:00 2018-06-28T17:00Z 25.86 11.66 85.8 nd 7.6 7.9 11.3 8.9 11.47 6.52 6.73 0.66 nd 26.7 35 28.26 SERC Dock 38.8869 -76.5407 YSI EXO2 SERC_6_28_18 5.65E+6 8.55E+5 2.68E+6 3.70E+5 SRR11791043 SRR11803379 SRR11784354, SRR11784353, SRR11784351, SRR11784350 7/5/18 2018-07-05T12:00 2018-07-05T17:00Z 31.64 13.26 92 1.17 7.7 7.7 11.8 8.1 11.77 6.65 6.52 0.82 9.76 26.1 37 25.65 SERC Dock 38.8869 -76.5408 YSI EXO2 SERC_7_5_18 4.33E+6 5.42E+5 2.21E+6 3.16E+5 SRR11791042 nd SRR11784349, SRR11784348, SRR11784347, SRR11784346 7/12/18 2018-07-12T12:00 2018-07-12T17:00Z 29.5 11.08 112.7 1.11 8.1 12.9 22.5 8.9 10.21 5.72 8.32 0.78 13.87 43.8 70 28.01 SERC Dock 38.8869 -76.5409 YSI EXO2 SERC_7_12_18 7.99E+6 1.68E+6 1.95E+6 8.85E+5 SRR11791041 nd SRR11784345, SRR11784344, SRR11784343, SRR11784342 7/19/18 2018-07-19T12:00 2018-07-19T17:00Z 28.69 12.55 79.2 1.08 7.7 11.1 12.3 8.9 11.72 6.65 5.91 0.76 17.66 37.5 38 27.97 SERC Dock 38.8869 -76.5410 YSI EXO2 SERC_7_19_18 7.62E+6 1.32E+6 1.53E+6 1.82E+5 SRR11791040 nd SRR11784340, SRR11784339, SRR11784338, SRR11784337 7/26/18 2018-07-26T12:00 2018-07-26T17:00Z 26.3 8.72 50.8 1 7.3 6.4 10.5 15.7 8.51 4.73 3.99 0.7 15.61 21.6 33 48.56 SERC Dock 38.8869 -76.5411 YSI EXO2 SERC_7_26_18 4.39E+6 5.44E+5 7.71E+5 8.82E+4 SRR11791039 nd SRR11784336, SRR11784335, SRR11784334 8/2/18 2018-08-02T12:00 2018-08-02T17:00Z 28.34 8.82 124.2 1.48 8.6 16.2 31.4 14 8.29 4.58 9.43 1.04 18.57 51.3 78 38.67 SERC Dock 38.8869 -76.5412 YSI EXO2 SERC_8_2_18 6.63E+6 5.68E+5 1.50E+6 1.79E+5 SRR11791053 SRR11803378 SRR11784333, SRR11784332, SRR11784331 8/9/18 2018-08-09T12:00 2018-08-09T17:00Z 30 8.02 60 1.33 7.9 5.4 14.3 12.4 7.32 4 4.44 0.94 17.07 17.2 36 34.33 SERC Dock 38.8869 -76.5413 YSI EXO2 SERC_8_9_18 6.25E+6 5.94E+5 9.45E+5 1.08E+5 SRR11791052 nd SRR11784329, SRR11784328, SRR11784327 8/23/18 2018-08-23T12:00 2018-08-23T17:00Z 25.83 7.2 74.4 1.46 7.9 13.7 31.2 13 7.09 3.88 5.92 1.03 27.71 43.5 78 35.9 SERC Dock 38.8869 -76.5414 YSI EXO2 SERC_8_23_18 5.63E+6 5.50E+5 3.06E+5 5.81E+4 SRR11791051 nd SRR11784326, SRR11784325, SRR11784324 12/6/18 2018-12-06T12:00 2018-12-06T17:00Z 6.14 3.74 87.5 1.6 7.8 1.9 4 12 5.85 3.16 10.63 1.12 6.95 6.6 13 37.57 SERC Dock 38.8869 -76.5415 YSI EXO2 SERC_12_6_18 5.04E+6 2.85E+5 2.74E+5 4.50E+4 SRR11791050 SRR11803377 SRR11784323, SRR11784322, SRR11784321 12/14/18 2018-12-14T12:00 2018-12-14T17:00Z 4.94 nd nd nd 7.97 4.3 8 11.2 nd 2.98 12.14 1.16 5.72 nd nd nd SERC Dock 38.8869 -76.5416 YSI EXO2 SERC_12_14_18 8.15E+6 6.98E+5 2.01E+5 3.05E+4 SRR11791049 nd SRR11784320, SRR11784318, SRR11784317 12/20/18 2018-12-20T12:00 2018-12-20T17:00Z 5.5 nd nd nd 8.18 6.3 10.2 13.1 nd 2.65 13 1.03 5.67 nd nd nd SERC Dock 38.8869 -76.5417 YSI EXO2 SERC_12_20_18 2.48E+6 2.44E+5 1.60E+5 3.37E+4 SRR11791048 nd SRR11784316, SRR11784315, SRR11784314 12/27/18 2018-12-27T12:00 2018-12-27T17:00Z 7.36 nd nd nd 8.51 14.5 29.7 10.7 nd 3.68 13.05 1.21 9.14 nd nd nd SERC Dock 38.8869 -76.5418 YSI EXO2 SERC_12_27_18 5.28E+6 9.15E+5 1.51E+5 5.43E+4 SRR11791047 nd SRR11784313, SRR11784312, SRR11784311 5/17/17 #1 2017-05-17T10:30 2017-05-17T15:30Z 18.59 9.24 97.8 1.29 8.07 4.7 9.2 5.4 10.52 5.98 8.83 0.9 8.43 21.5 30 nd SERC Dock 38.8869 -76.5402 YSI EXO2 SERC_5_17_17_1 nd nd 385 7.87 SRR11811741 nd nd 5/17/17 #2 2017-05-17T12:00 2017-05-17T17:00Z 19.67 9.35 106 1.27 8.18 2 4.8 5.4 10.41 5.91 9.37 0.89 8.97 10.1 17 nd SERC Dock 38.8869 -76.5402 YSI EXO2 SERC_5_17_17_2 nd nd 594 69.9 SRR11811740 nd nd 5/17/17 #3 2017-05-17T13:30 2017-05-17T18:30Z 19.81 9.13 113.4 1.27 8.32 3.2 7 6.3 10.13 5.74 10.01 0.89 10.07 15.4 23 nd SERC Dock 38.8869 -76.5402 YSI EXO2 SERC_5_17_17_3 nd nd 584 103 SRR11811734 SRR11803505 nd 5/17/17 #4 2017-05-17T15:00 2017-05-17T20:00Z 20.24 9.24 118.8 1.25 8.39 6 13.8 6 10.17 5.76 10.4 0.88 10.94 26.6 43 nd SERC Dock 38.8869 -76.5402 YSI EXO2 SERC_5_17_17_4 nd nd 321 24.4 SRR11811733 SRR11803504 nd 5/17/17 #5 2017-05-17T16:30 2017-05-17T21:30Z 20.47 9.53 124.7 1.25 8.47 6.3 12.3 5.4 10.43 5.92 10.85 0.88 10.83 27.9 39 nd SERC Dock 38.8869 -76.5402 YSI EXO2 SERC_5_17_17_5 nd nd 287 62.3 SRR11811732 SRR11803502 nd 5/18/17 #1 2017-05-18T10:30 2017-05-18T15:30Z 19.75 9.53 97.2 1.25 8.06 5.6 11.3 5 10.59 6.02 8.58 0.88 9.62 25.1 36 nd SERC Dock 38.8869 -76.5402 YSI EXO2 SERC_5_18_17_1 nd nd 1.79E+3 281 SRR11811731 SRR11803501 nd 5/18/17 #2 2017-05-18T12:00 2017-05-18T17:00Z 22.06 9.97 123.6 1.23 8.38 5.3 8.9 4.5 10.57 5.99 10.42 0.86 7.38 24 29 nd SERC Dock 38.8869 -76.5402 YSI EXO2 SERC_5_18_17_2 nd nd 2.01E+3 308 SRR11811730 SRR11803500 nd 5/18/17 #3 2017-05-18T13:30 2017-05-18T18:30Z 22.21 10.01 123.7 1.22 8.39 4.1 8.9 4.9 10.57 5.99 10.4 0.85 8.15 19 29 nd SERC Dock 38.8869 -76.5402 YSI EXO2 SERC_5_18_17_3 nd nd 1.60E+3 113 SRR11811729 SRR11803499 nd 5/18/17 #4 2017-05-18T15:00 2017-05-18T20:00Z 23.39 10.08 136.6 1.2 8.53 5.8 11 4.8 10.4 5.88 11.25 0.84 8.87 26.1 35 nd SERC Dock 38.8869 -76.5402 YSI EXO2 SERC_5_18_17_4 nd nd 2.74E+3 86.0 SRR11811728 SRR11803498 nd 5/18/17 #5 2017-05-18T16:30 2017-05-18T21:30Z 24.07 10.18 146.2 1.19 8.6 6.8 12.7 4.8 10.37 5.86 11.89 0.83 9.25 29.9 40 nd SERC Dock 38.8869 -76.5402 YSI EXO2 SERC_5_18_17_5 nd nd 2.96E+3 671 SRR11811727 SRR11803497 nd 5/19/17 #1 2017-05-19T10:30 2017-05-19T15:30Z 22.21 9.97 120 1.22 8.41 6.1 11.8 4.8 10.53 5.97 10.1 0.86 7.68 27.3 38 nd SERC Dock 38.8869 -76.5402 YSI EXO2 SERC_5_19_17_1 nd nd 2.94E+3 748 SRR11811739 SRR11803496 nd 5/19/17 #2 2017-05-19T12:00 2017-05-19T17:00Z 23.19 10.19 118.1 1.2 8.35 3.4 7.3 4.6 10.55 5.97 9.75 0.84 7.09 16.1 24 nd SERC Dock 38.8869 -76.5402 YSI EXO2 SERC_5_19_17_2 nd nd 3.81E+3 708 SRR11811738 SRR11803495 nd 5/19/17 #3 2017-05-19T13:30 2017-05-19T18:30Z 22.76 10.1 131.5 1.19 8.52 8.4 16.6 5 10.55 5.98 10.95 0.83 8.71 36.9 52 nd SERC Dock 38.8869 -76.5402 YSI EXO2 SERC_5_19_17_3 nd nd 3.48E+3 220 SRR11811737 SRR11803503 nd 5/19/17 #4 2017-05-19T15:00 2017-05-19T20:00Z 23.79 10.33 136.3 1.17 8.54 6.7 12.2 4.7 10.57 5.98 11.13 0.82 7.96 29.8 39 nd SERC Dock 38.8869 -76.5402 YSI EXO2 SERC_5_19_17_4 nd nd 2.49E+3 374 SRR11811736 nd nd 5/19/17 #5 2017-05-19T16:30 2017-05-19T21:30Z 24.09 10.38 139.7 1.16 8.55 5.8 11 4.7 10.56 5.97 11.35 0.82 7.62 26.1 35 nd SERC Dock 38.8869 -76.5402 YSI EXO2 SERC_5_19_17_5 nd nd 631 35.4 SRR11811735 nd nd